[dbo].[BAEImisActivityGetAllByUserIdActivityType]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEImisActivityGetAllByUserIdActivityType

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@UserId	varchar(10)	10
@ActivityType	varchar(10)	10

SQL Script

create procedure [dbo].[BAEImisActivityGetAllByUserIdActivityType] @UserId as
varchar(10),
    @ActivityType    AS    varchar(10)
AS
    SELECT * FROM Activity
    WHERE ID = @UserId AND ACTIVITY_TYPE = @ActivityType
    ORDER BY SEQN

GO

Uses

[dbo].[Activity]
dbo